export const SpecialistQueries = {
    GetSpecialists: `
    SELECT
      id,
      specialistName,
      employeeId
      specialistSource,
      specialistEduBackground,
      specialistEduDegree,
      specialistCategory,
      specialistSubject,
      specialistHonor,
      specialistOrganization,
      specialistDirection
    FROM my_schema.specialist
    `,
  
    GetSpecialistById: `
    SELECT
      id,
      specialistName,
      employeeId,
      specialistSource,
      specialistEduBackground,
      specialistEduDegree,
      specialistCategory,
      specialistSubject,
      specialistHonor,
      specialistOrganization,
      specialistDirection
    FROM my_schema.specialist
    WHERE
      id = ?
    `,

    AddSpecialist: `
    INSERT INTO my_schema.specialist (id, specialistName, employeeId, specialistSource, specialistEduBackground, specialistEduDegree, specialistCategory, specialistSubject, specialistHonor, specialistOrganization, specialistDirection)
      VALUES ?
    `,

    UpdateSpecialistById: `
    UPDATE my_schema.specialist
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteSpecialistById: `
    DELETE FROM my_schema.specialist
    WHERE
      id = ?
    `
  };